How to: Create a separate chart sheet.
Solution:
Select the rows/columns to chart, select 'Chart' from the 'Insert' menu, select 'As New Sheet', and specify the type of chart and the format.
1) Open the desired workbook.
2) Click the tab for the worksheet that contains the desired data.
3) Select the rows and/or columns to chart, including any label text.
4) Select the 'Insert' menu and select 'Chart'. (A submenu appears.)
5) Select 'As New Sheet' from the submenu. (The ChartWizard - Step 1 of 5 dialog box appears.)
ChartWizard Step 1 of 5
NOTE: The range in the 'Range' box defaults to the data selected in Step 3).
6) Click 'Next'. (The ChartWizard - Step 2 of 5 dialog box appears.)
ChartWizard Step 2 of 5
7) Select the desired chart type from the 'Select a chart type' box.
8) Click 'Next'. (The ChartWizard - Step 3 of 5 dialog box appears.)
ChartWizard Step 3 of 5
9) Select the desired format for the chart from the 'Select a format for the <x> chart' box, where <x> stands for the type of chart selected in Step 9).
10) Click 'Next'. (The ChartWizard - Step 4 of 5 dialog box appears with a sample chart that uses the selected data.)
ChartWizard Step 4 of 5
11) Make sure that the sample chart correctly presents the selected data.
12) (Optional) To change the data presentation, do one or more of the following:
a) Change to the other option in the 'Data Series in' group.
b) Specify the row containing the text to use as the X-axis labels in the 'Category (X)' box.
c) Specify the column containing the text to use as the Y-axis labels in the 'Value (Y)' box.
13) Click 'Next'. (The ChartWizard - Step 5 of 5 dialog box appears.)
ChartWizard step 5 of 5
NOTE: The sample chart in this dialog box incorporates any changes made in the previous dialog box.
14) (Optional) Specify whether to add a legend to the chart in the 'Add a Legend?' group.
NOTE: Any additions or changes made in the dialog box are immediately reflected in the sample chart.
15) (Optional) Type a title for the chart in the 'Chart Title' box.
16) (Optional) Type a title for the X-axis in the 'Category (X)' box of the 'Axis Titles' group.
17) (Optional) Type a title for the Y-axis in the 'Value (Y)' box of the 'Axis Titles' group.
18) Click 'Finish'. (A chart appears in a separate chart sheet.)
19) (Optional) Resize the chart so that it appears properly.
